UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UqvhQ59v67lm5dvtcFPZ2u0e9mskZAEDpD3qSspfM3c='
WHERE
key_id = '9a42559cce973974ab958a7712e8567381ade78840abf83304d46eea50518b8e'
AND (
token = 'UqvhQ59v67lm5dvtcFPZ2u0e9mskZAEDpD3qSspfM3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)