UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esAgjcQTN88/0ieFzumGeS3H9B75Unw6zy2QBiM19T8='
WHERE
key_id = '5d1c4ddd8995e3edef07edfa331facbca8ca1914cc214f1e523c6785831a56cf'
AND (
token = 'esAgjcQTN88/0ieFzumGeS3H9B75Unw6zy2QBiM19T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)