UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a2nQnsnZsjtw8IaJQVYB13l6JrKOzqkgvb+Y9NISxrE='
WHERE
key_id = '931e475e8f236555b51d4f462f3e8bf3877bd857b6f943b5e2a182c4f40f152a'
AND (
token = 'a2nQnsnZsjtw8IaJQVYB13l6JrKOzqkgvb+Y9NISxrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)