UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmXJKgCenl4DuqXt2g6fr/MwgHLlPHToewf9DYjaRIU='
WHERE
key_id = 'bbf66eae6c1c768942f80fa00c70bbf2cd707a9187d701383a3c8823bd7b8dab'
AND (
token = 'fmXJKgCenl4DuqXt2g6fr/MwgHLlPHToewf9DYjaRIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)