UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQvk7uqeBHDFRr7dqb7eaRjdcAyHKZIUIIQWWGB2stA='
WHERE
key_id = '6a7c265583aee71af4bac66e4d9e1728e5bb221bd3cdb30eaec6b367fdb52b94'
AND (
token = 'ZQvk7uqeBHDFRr7dqb7eaRjdcAyHKZIUIIQWWGB2stA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)