UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Msbk31zEQO0dvVIot8VY0pi59oHK9VO4apjfsKg0nLQ='
WHERE
key_id = 'a85bfab2a9bd4e4cfe62b605aa276aa3a46669f63968c0f7eeabfe2c10e4e37a'
AND (
token = 'Msbk31zEQO0dvVIot8VY0pi59oHK9VO4apjfsKg0nLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)