MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (
  `id` VARCHAR(1),
  `lst_redeem_op_time` DATETIME
);

INSERT INTO table1
  (`id`, `lst_redeem_op_time`)
VALUES
  ('a', '2020-07-22 11:14:37'),
  ('a', '2020-07-28 11:14:37'),
  ('a', '2020-07-30 14:55:04'),
  ('b', '2020-07-27 11:14:37'),
  ('b', '2020-07-28 11:14:37'),
  ('b', '2020-08-15 11:14:37'),
  ('c', '2020-07-27 11:14:37'),
  ('c', '2020-07-29 11:14:37'),
  ('c', '2020-07-31 11:14:37');
 SELECT 
 t1.`id`, `lst_redeem_op_time`
 FROM table1 t1 
 INNER JOIN       (SELECT `id`, MAX(DATE_ADD(`lst_redeem_op_time`, INTERVAL - 2 DAY)) max_time FROM table1 GROUP BY id) t2 ON t1.id = t2.id 
WHERE t1.`lst_redeem_op_time` < t2.max_time;


id
lst_redeem_op_time


a
2020-07-22 11:14:37

a
2020-07-28 11:14:37

b
2020-07-27 11:14:37

b
2020-07-28 11:14:37

c
2020-07-27 11:14:37


DELETE t1
FROM table1 t1
        INNER JOIN
      (SELECT `id`, MAX(DATE_ADD(`lst_redeem_op_time`, INTERVAL - 2 DAY)) max_time FROM table1 GROUP BY id) t2 ON t1.id = t2.id 
WHERE t1.`lst_redeem_op_time` < t2.max_time;
SELECT * FROM table1


id
lst_redeem_op_time


a
2020-07-30 14:55:04

b
2020-08-15 11:14:37

c
2020-07-29 11:14:37

c
2020-07-31 11:14:37

id	lst_redeem_op_time
a	2020-07-22 11:14:37
a	2020-07-28 11:14:37
b	2020-07-27 11:14:37
b	2020-07-28 11:14:37
c	2020-07-27 11:14:37

id	lst_redeem_op_time
a	2020-07-30 14:55:04
b	2020-08-15 11:14:37
c	2020-07-29 11:14:37
c	2020-07-31 11:14:37