> The problem comes with the ('NOW' - STATUS_CHANGED) > 1/24
> (STATUS_CHANGED IS A TIMESTAMP) , trying to run the sql I get an error
> about not being able to do the comparison?

'NOW' is string literal, not timestamp value.

Either use
CAST('NOW' AS TIMESTAMP)
or
CURRENT_TIMESTAMP

Ivan