UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8wKzHMEeEosHgEIb12m1zirA71fSGNxTTCdizNrviI='
WHERE
key_id = '8ffb24eba15505e77d23a036fd88e0a05ac101e0c255106f6022942df466cdaf'
AND (
token = 'N8wKzHMEeEosHgEIb12m1zirA71fSGNxTTCdizNrviI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)