UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UhCVY8VfxfYWTIQr9FugXviagxdWnn6WpthF9HfATQA='
WHERE
key_id = 'a6ce0601aed8e1e78e0d02df9d7312e6bc7cee42c91cfbb3560e905b60983ae0'
AND (
token = 'UhCVY8VfxfYWTIQr9FugXviagxdWnn6WpthF9HfATQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)