Summary:
`PgGetLockStatusTest*` tests fail occasionally is tsan mode with the following error
```
../../src/yb/yql/pgwrapper/geo_transactions_test_base.cc:255
Failed
Bad status: Timed out (yb/util/backoff_waiter.cc:78): Operation 'Timed out waiting for transaction manager to update status tablet cache version to 1' didn't complete within 20000ms
```

We seem to not have set a lower value for `FLAGS_ysql_tablespace_info_refresh_secs` in `PgLocksTestBase` like we do in `GeoTransactionsTestBase`. This diff lowers the flag value for `PgLocksTestBase` which address the tsan flakiness.

Test Plan: ./yb_build.sh tsan --cxx-test pgwrapper_pg_get_lock_status-test --gtest_filter PgGetLockStatusTestRF3.TestPrioritizeLocksOfOlderTxns -n 10 --tp 1

Reviewers: smishra, esheng

Reviewed By: esheng

Subscribers: yql, ybase

Differential Revision: https://phorge.dev.yugabyte.com/D39778