UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+52SbuJcggAIgfAAmYzoz5NpahLQqV7wY6l3ugT8Cvs='
WHERE
key_id = 'ef98a0daf0e0347828f899f98bd1a17bd395505533fcfd768fedcb4887cefb53'
AND (
token = '+52SbuJcggAIgfAAmYzoz5NpahLQqV7wY6l3ugT8Cvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)