UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KsM+i+UCjOil8coTW4H79y+daWDMeyBEOTPJOqIgV+E='
WHERE
key_id = 'd65bf7a76dfe7d9f7113bf130affa6a22a3b9f6bc5c6007ec3be0257ad3fce49'
AND (
token = 'KsM+i+UCjOil8coTW4H79y+daWDMeyBEOTPJOqIgV+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)