MySQL之查询20分钟未支付订单

//status = 0 为未支付状态
select * FROM order  WHERE TIMESTAMPDIFF(MINUTE,create_date,now())  > 20 AND status = 0;