[Feature] Improve catalog lock for paimon

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.

### Motivation

Currently paimon only support hive lock for hive catalog, it should support unified lock for filesystem catalog

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by locating the existing Hive lock implementation and the filesystem catalog entry point. Compare their locking behavior and determine the scope of a unified lock for filesystem catalogs. Done means filesystem catalogs support the intended unified locking behavior, with coverage for the relevant catalog and lock cases.

Written by the indexing model from the issue text.