fix(postgres,pgx): use pg_try_advisory_lock with exponential backoff in Lock

fix(postgres,pgx): use pg_try_advisory_lock with exponential backoff in Lock #1458