I found the problem
NULL is not different from DATETIME('now','localtime')
so I changed the condition to
**WHEN OLD.Modified is NULL OR OLD.Modified != DATETIME('NOW','localtime')**
But then it will update the Modified column on insert
So i might as well not include the WHEN statement...