UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sHSHy4g6xY7C0KkKysYxZNHFx55fsfQ88rRRZz/Nyo='
WHERE
key_id = 'a1862e9ae864ce69b0428200588f962ba68bcb50979e6b5a6c0be52b702175e6'
AND (
token = '9sHSHy4g6xY7C0KkKysYxZNHFx55fsfQ88rRRZz/Nyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)