tl;dr "Unless you plan to delete a row or modify a key column, always use SELECT FOR NO KEY UPDATE".