declare @MyFiles table (
  [Id] int identity(1,1),
  [FileName] sysname,
  [FolderName] sysname,
  [KeyPairs] nvarchar(max)
);

insert into @MyFiles values 
('test.txt', 'C:\', '{"Licence No ": "12345", "ID Number ": "345678", "Class ": "1AC ", "Card Number ": "6 666 666 666 ", "Expiry Date ": "22 DEC 2016 "}'),
('test.txt', 'C:\', '{"Licence No ": "54321", "ID Number ": "333333", "Class ": "1AC ", "Card Number ": "7 777 777 777 ", "Expiry Date ": "17 DEC 2021 "}');

with x as (
    select
          f.[Id],
          f.[FileName],
          f.[FolderName],
          o.[License No],
          o.[ID Number],
          o.[Class],
          o.[Card Number],
          o.[Expiry Date],
          try_parse(o.[Expiry Date] as datetime) as [date]
    from @MyFiles f
    cross apply openjson (f.[KeyPairs])  with (
      [License No] varchar(255) '$."Licence No "',
      [ID Number] varchar(255) '$."ID Number "',
      [Class] varchar(255) '$."Class "',
      [Card Number] varchar(255) '$."Card Number "',
      [Expiry Date] varchar(255) '$."Expiry Date "'
    ) o
)
select * from x where [date] >= getdate();