Nice - that's a good case for barriers too. When there's no row to SELECT FOR UPDATE against, you'd inject the barrier after acquiring the advisory lock and verify the second transaction blocks until the first commits.

I always did "INSERT ... ON CONFLICT DO NOTHING".

Seems like a good way to materialize the conflict.