There is an inherent flaw in this code and generally manifests itself under heavier than normal load.  This is because "select" statement does not lock the row being read that...