SQL Unable to filter using DATE_ADD or DATEDIFF in the subquery, MySQL

Language: Layout:

CREATE TABLE IF NOT EXISTS record_history (
  `revision` INT(11) NOT NULL,
  `record_id` BIGINT(20) NOT NULL,
  `creation_date` DATETIME NULL DEFAULT NULL,
  `record_status_id` BIGINT(20) NULL DEFAULT NULL,
  `last_updated_date` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY USING BTREE (`record_id`, `revision`))
ENGINE = InnoDB;

INSERT INTO record_history(revision,record_id,creation_date,record_status_id,last_updated_date) VALUES
( 239,59,'2016-01-18 16:23:00',1,'2016-01-19 10:18:00'),
( 284,59,'2016-01-18 16:23:00',2,'2016-01-19 12:12:00'),
( 302,59,'2016-01-18 16:23:00',2,'2016-01-20 15:18:00'),
( 304,59,'2016-01-18 16:23:00',2,'2016-01-25 16:26:00'),
( 305,59,'2016-01-18 16:23:00',1,'2016-05-24 16:29:00'),
( 307,59,'2016-01-18 16:23:00',2,'2016-05-25 11:33:00'),
( 309,59,'2016-01-18 16:23:00',1,'2016-07-07 10:15:00'),
( 310,59,'2016-01-18 16:23:00',2,'2016-08-07 12:44:00'),
( 489,59,'2016-01-18 16:23:00',1,'2016-11-11 02:12:00'),
( 492,59,'2016-01-18 16:23:00',1,'2016-11-11 05:25:00'),
( 502,59,'2016-01-18 16:23:00',2,'2016-11-12 10:12:00'),
( 504,59,'2016-01-18 16:23:00',2,'2016-12-05 11:23:00'),
( 509,59,'2016-01-18 16:23:00',1,'2016-12-11 12:24:00'),
( 519,59,'2016-01-18 16:23:00',1,'2016-12-11 14:30:00'),
( 524,59,'2016-01-18 16:23:00',1,'2016-12-11 15:36:00'),
( 674,59,'2016-01-18 16:23:00',1,'2016-12-11 17:45:00');

-- select * from record_history;
SELECT revision, record_id, record_status_id, last_updated_date FROM record_history AS a
WHERE a.record_status_id = 2
and a.record_status_id <> ( SELECT b.record_status_id FROM record_history AS b
                                WHERE a.record_id = b.record_id
                                AND a.last_updated_date < b.last_updated_date
                                -- AND DATEDIFF(b.utc_last_updated_date, a.utc_last_updated_date) > 90
                                -- and b.utc_last_updated_date > DATE_ADD(a.utc_last_updated_date,INTERVAL 90 DAY)
                                LIMIT 1
                              );


Absolute service time: 0,5 sec, absolute service time: 0,51 sec