I changed time filter and loading/ loaded filter, could you please try this?

SELECT b.bill_number, 
       b.detail_line_id, 
       b.callname, 
       b.destname, 
       a.trip_number, 
       b.deliver_by, 
       a.status_code
FROM odrstat a
LEFT JOIN tlorder b 
  ON a.order_id = b.detail_line_id
WHERE a.trip_number = 62886 
  AND NOT EXISTS (
      SELECT 1 
      FROM odrstat c
      WHERE c.order_id = a.order_id 
        AND c.status_code IN ('LOADING', 'LOADED')
  )
  AND b.deliver_by >= CURRENT_TIMESTAMP + INTERVAL 3 HOUR
  AND b.deliver_by < CURRENT_TIMESTAMP + INTERVAL 4 HOUR
GROUP BY b.bill_number, 
         b.detail_line_id, 
         b.callname, 
         b.destname, 
         a.trip_number, 
         b.deliver_by, 
         a.status_code;