MySQL 8.0

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

CREATE TABLE rent_logs (
car varchar(30),
user varchar(30),
location varchar(30),
time datetime,
type varchar(10)
);
INSERT INTO rent_logs ( car, user, location, time, type ) VALUES
( 1, 'Ben', 'Chicago','2022-02-12 03:12:45',  'OUT' ), 
( 1, 'Ben', 'Chicago',' 2022-02-12 03:12:45  ',  'IN' ), 
( 2, 'Sam', 'New york','2022-02-12 04:42:45',  'OUT' ), 
( 1, 'Ben', 'Chicago','2022-02-12 04:50:00',  'OUT' ), 
( 2, 'Sam', 'New york','2022-02-12 07:32:12 ',  'IN' ), 
( 1, 'Ben', 'Chicago','2022-02-12 08:18:45',  'IN' ), 
( 3, 'Mia', 'Chicago','2022-02-12 09:12:43',  'OUT' ), 
( 1, 'Ben', 'Chicago','2022-02-12 09:27:23',  'IN' )

Records: 8  Duplicates: 0  Warnings: 2


DELETE r
FROM rent_logs r
INNER JOIN (
  SELECT car, user, location, time
  FROM rent_logs
  GROUP BY car, user, location, time
  HAVING COUNT(*) > 1
) t ON (t.car, t.user, t.location, t.time) = (r.car, r.user, r.location, r.time);
SELECT * FROM rent_logs;


car
user
location
time
type


2
Sam
New york
2022-02-12 04:42:45
OUT

1
Ben
Chicago
2022-02-12 04:50:00
OUT

2
Sam
New york
2022-02-12 07:32:12
IN

1
Ben
Chicago
2022-02-12 08:18:45
IN

3
Mia
Chicago
2022-02-12 09:12:43
OUT

1
Ben
Chicago
2022-02-12 09:27:23
IN

car	user	location	time	type
2	Sam	New york	2022-02-12 04:42:45	OUT
1	Ben	Chicago	2022-02-12 04:50:00	OUT
2	Sam	New york	2022-02-12 07:32:12	IN
1	Ben	Chicago	2022-02-12 08:18:45	IN
3	Mia	Chicago	2022-02-12 09:12:43	OUT
1	Ben	Chicago	2022-02-12 09:27:23	IN