Async shared backend support improvements

[toloco]

Priority: Lower / long-term

Why

Async workloads are growing and the shared backend should integrate well.

Ideas

• Async single-flight (dogpile prevention for async)
• Non-blocking waits (avoid blocking the event loop on lock contention)