UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFJU07Ora8/i9/Dyhmof4ZsvTW57n99DaFPPB4UFoPA='
WHERE
key_id = '97bd9710c1f9132df4525fe11d37dc4055b55629ac68a36acf9ce3d2897edfd3'
AND (
token = 'ZFJU07Ora8/i9/Dyhmof4ZsvTW57n99DaFPPB4UFoPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)