SNOW-984600 Avoid closing expired sessions synchronously with obtained lock

[sfc-gh-knozderko]

Description

Avoid closing sessions synchronously with obtained lock

Checklist

• Code compiles correctly
• Code is formatted according to Coding Conventions
• Created tests which fail without the change (if possible)
• All tests passing (dotnet test)
• Extended the README / documentation, if necessary
• Provide JIRA issue id (if possible) or GitHub issue id in PR name

[codecov]

Codecov Report

Attention: 3 lines in your changes are missing coverage. Please review.

Comparison is base (3710031) 83.54% compared to head (6be094a) 83.49%.

Files	Patch %	Lines
Snowflake.Data/Core/Session/SFSession.cs	50.00%	0 Missing and 2 partials ⚠️
Snowflake.Data/Core/Session/SessionPool.cs	66.66%	1 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##           master     #830      +/-   ##
==========================================
- Coverage   83.54%   83.49%   -0.06%     
==========================================
  Files          89       89              
  Lines        9188     9189       +1     
  Branches      841      841              
==========================================
- Hits         7676     7672       -4     
- Misses       1281     1285       +4     
- Partials      231      232       +1     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.