UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7zKnuDQIEah6m+hgJTmefZ+JEf20Zl2TA86ivQK89Q='
WHERE
key_id = '2549dcf0c41bb59f14971144230fd2b166dd25e6cd94ecb96899ee6e4982524a'
AND (
token = 'A7zKnuDQIEah6m+hgJTmefZ+JEf20Zl2TA86ivQK89Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)