UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/Lm3Rm0fG8J2AjzFS9c7e7Bp6kwi1Q+eK2YYOryywM='
WHERE
key_id = 'c7f1ab16f793ad86b55f12ee28ac090e875c530eaf58731a8f9d04ae81c48d12'
AND (
token = 'C/Lm3Rm0fG8J2AjzFS9c7e7Bp6kwi1Q+eK2YYOryywM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)