Mediusflow: Unlock reserved tasks

gistfile1.sql

UPDATE e
SET e.reservedby = NULL
FROM ERRAND e
INNER JOIN ERRAND_HISTORY eh ON (e.ID = eh.ERRANDID
                                 AND eh.Tag = 'ERRAND_RESERVED')
WHERE e.RESERVEDBY IS NOT NULL
    AND eh.MODIFIEDDATE < DATEADD(MINUTE, -60, GETDATE())
    AND eh.ID =
        (SELECT top 1 ID
         FROM ERRAND_HISTORY
         WHERE ERRANDID = e.ID
         ORDER BY ID DESC)