UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fBSwMAJKW/KoNCTculT+4T2LOLxKTHT0Umgi/eAYIF8='
WHERE
key_id = 'af3a41137b2b4a742c2e969c8549fad23e92e432399700a234a3c6806ec2c014'
AND (
token = 'fBSwMAJKW/KoNCTculT+4T2LOLxKTHT0Umgi/eAYIF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)