fix: Add correct type for state_backend lock settings

[cjohnhanson]

Also reduces default lock timeout to a more reasonable 10 seconds.

Closes #7525

[netlify]

✅ Deploy Preview for meltano canceled.

Name	Link
🔨 Latest commit	de3cbf1
🔍 Latest deploy log	https://app.netlify.com/sites/meltano/deploys/64388763caea070008c9b72c

[WillDaSilva]

@cjohnhanson You'll have to regenerate the sample manifest files to get the integration tests passing.

[codecov]

Codecov Report

Merging #7537 (04260a9) into main (0be994f) will increase coverage by 0.00%.
The diff coverage is n/a.

❗ Current head 04260a9 differs from pull request most recent head de3cbf1. Consider uploading reports for the commit de3cbf1 to get more accurate results

@@           Coverage Diff           @@
##             main    #7537   +/-   ##
=======================================
  Coverage   89.40%   89.40%           
=======================================
  Files         294      294           
  Lines       21684    21684           
  Branches     2426     2426           
=======================================
+ Hits        19386    19387    +1     
+ Misses       1939     1938    -1     
  Partials      359      359           

see 1 file with indirect coverage changes

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more