use table locks to prevent stale reads from trigger (MRXN23-572)

use table locks to prevent stale reads from trigger (MRXN23-572) #1479