UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RXHmiYG4saCE/DIJG9hOcCcmpIqAjbWVZs+jCezPOnU='
WHERE
key_id = 'a8b6ca493848ec0a60867c7899f1ee83693b26da4ffd49a96180d79f2a84f0e0'
AND (
token = 'RXHmiYG4saCE/DIJG9hOcCcmpIqAjbWVZs+jCezPOnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)