A practical guide to AI agent concurrency control: per-record locking, tenant limits, worker pools, queue boundaries, and the rules that stop parallel runs from duplicating work or corrupting state.