vw_lock_contention occurs if two edits to the same article are submitted at exactly the same time. The lock should expire after the first edit finishes saving, or after 5 minutes, whichever comes first.
After 5 minutes, it is assumed that the first edit failed for some reason, so the lock is released. I believe locks were introduced in 4.0.4, but the auto-release was not added until a later build of that version. You may need to upgrade if the lock is still not released after a long time.