仅仅用一条语句，删除过期的记录，仅保留最新的30条，利用left join，把30条之外的join成null

delete a from history a left join (
  select id from history 
  order by create_time desc limit 30) b on a.id = b.id 
where b.id is null;