UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zl3N6knh9p6y6MUlyTaw5scPxTT3V8gms8km3ORI060='
WHERE
key_id = '6bff8308fe20b018fa303b1596c7f023d9f5561008cd2e30b90732a5963d9ac4'
AND (
token = 'Zl3N6knh9p6y6MUlyTaw5scPxTT3V8gms8km3ORI060='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)