UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Eha8trz3qBu9Am+qZo0BvuRo1pRXj4olg2EOCP8kJs8='
WHERE
key_id = 'c31aafb19fe0fe1fbd314e1cbcb4cd98ce79e8ab1a9d4f234cbcf3cabc6d2ec4'
AND (
token = 'Eha8trz3qBu9Am+qZo0BvuRo1pRXj4olg2EOCP8kJs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)