Clarify delete CAS behavior

This patch adds a test to better define the correct behavior for using the `ScanCAS()` API to conditionally delete rows.