Thanks Ivan

it works with

SELECT * FROM PINS
WHERE
(STATUS = 7 OR STATUS = 8 OR STATUS =1 OR STATUS =9) AND
((CURRENT_TIMESTAMP - STATUS_CHANGED) > 1/24)

Rgds

Peter