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