CREATE TABLE missions (
  id BIGINT AUTO_INCREMENT  PRIMARY KEY,
  mission_id VARCHAR(36),
  last_status VARCHAR(30),
  ts_create BIGINT,
  ts_update BIGINT,
  ts_complete BIGINT,
  responder_id INT,
  status VARCHAR(10)
);


CREATE TABLE missions (
  mission_id VARCHAR(36),
  last_status VARCHAR(30),
  ts_create BIGINT,
  ts_update BIGINT,
  ts_complete BIGINT,
  responder_id INT,
  status VARCHAR(10)
);
-------------------------------------------------------
INSERT INTO missions (mission_id,
                      last_status,
                      ts_create,
                      ts_update,
                      responder_id,
                      status)
VALUES ('3685a7f7-6185-46bf-9a36-f8e7d53df7d8',
        'MissionStartedEvent',
        1580219357000,
        1580219357000,
        165,
        'CREATED');
----------------------------------------------------------
UPDATE missions
SET ts_update = 1580219357,
    last_status = 'MissionPickedUpEvent',
    status = 'UPDATED'
WHERE mission_id = '3685a7f7-6185-46bf-9a36-f8e7d53df7d8';
----------------------------------------------------------
UPDATE missions
SET ts_complete = 160000000,
    last_status = 'MissionCompletedEvent',
    status = 'COMPLETED'
WHERE mission_id = '1585a7f7-6185-46bf-9a36-f8e7d53df7d8';


MYSQL:
SELECT *
FROM missions
WHERE (UNIX_TIMESTAMP() - last_status) > 3600000
AND status <> 'COMPLETED';


POSTGRESQL:
SELECT * from missions where to_timestamp(ts_update/1000) < (now() - INTERVAL '1 hour') AND status <> 'COMPLETED';