Add advisory lock

Add a basic Lock that use ``pg_advisory_lock`` underneath.