UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHtRHBZOUKtl2/zvu8FooXrxyxLRhm2Ccoe8RODAoFU='
WHERE
key_id = 'fa8415242cdae9b4c857e885d6d9efa6ce10b9a43b6b3453480559193a09a379'
AND (
token = 'gHtRHBZOUKtl2/zvu8FooXrxyxLRhm2Ccoe8RODAoFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)