UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7NSdvyqY6HYaIgnhTgutdj8yMwZbzE1PWYCegXjgzM='
WHERE
key_id = '368b7c5af95ef7e332dfba3c61ad084bd566fe3f192e599409d40b18108a5c2e'
AND (
token = 'H7NSdvyqY6HYaIgnhTgutdj8yMwZbzE1PWYCegXjgzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)