UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd6fnraRKGOoOJJ+t7O/sSwVzVjEBv24R797LltLr6tw='
WHERE
key_id = 'e1e4174dcadf950166ecd7957136cd4cf6f9ffafa60f1973b1f23cec59ba425c'
AND (
token = 'd6fnraRKGOoOJJ+t7O/sSwVzVjEBv24R797LltLr6tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)