UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHFMMW3eGsFV8oBbriqOoEv9CCvO1aap1qs51q+jO6E='
WHERE
key_id = '78da59255667e9e54cb6b3ca346548895444ad16ece9e275de98195a132cfefa'
AND (
token = 'FHFMMW3eGsFV8oBbriqOoEv9CCvO1aap1qs51q+jO6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)