UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCw4fizYBoWIK0COqb1jekJl0JvaIPWWrY9qgNEAgck='
WHERE
key_id = '857aace30195199d0c1a74607108f116d9b94938881c69d3cc25f176294cd887'
AND (
token = 'ZCw4fizYBoWIK0COqb1jekJl0JvaIPWWrY9qgNEAgck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)