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