Code:
SELECT dbo.UserConfig.DisplayName, dbo.UserConfig.UserName, dbo.UserConfig.PIN, dbo.UserConfig.KeyGenExpiryTime, dbo.UserConfig.KeyGenMaxAttempts, dbo.UserConfig.KeyGenPassword, dbo.UserConfig.KeyGenNumAttempts, dbo.UserConfig.KeyGenState FROM dbo.UserConfig WHERE keygenexpirytime > GETDATE()
Great (and useful) query!