UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YYbaLyFXQXDDG8NrIMXcfJ3LUfxuLeSySin+hfWi24='
WHERE
key_id = 'ab97ccd8b95299c5f7aebd28815608124bce462dba5e102b817e015b41342ee5'
AND (
token = '7YYbaLyFXQXDDG8NrIMXcfJ3LUfxuLeSySin+hfWi24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)