We wrote a bit about how "Solid Queue" uses "UPDATE SKIP LOCKED". https://www.bigbinary.com/blog/solid-queue