UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VwgzkIb9Tx5h3jWMFqAP6rgpipN2V+T/wRNZMewwsYE='
WHERE
key_id = 'c31269ed92e8e39acf843f83db00a4ef6ff29f2d7fe32473d5dedf0cf6a95314'
AND (
token = 'VwgzkIb9Tx5h3jWMFqAP6rgpipN2V+T/wRNZMewwsYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)