UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1l7JGpJVXAAIUXmHc1BTSyyVO4sd17P9kZSwsoiJT/U='
WHERE
key_id = '9f5a49c3a7cb37ce260313d447c7a266d6f814065d1d7f1d04cef701472e4875'
AND (
token = '1l7JGpJVXAAIUXmHc1BTSyyVO4sd17P9kZSwsoiJT/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)