Is it possible to use .or() in an update w/ .select()?

I've been trying to basically run this query through the supabase abstraction:

  UPDATE notifications
  SET processingAt = NOW()
  WHERE (processingAt IS NULL OR processingAt < '${fiveMinutesAgo}')
    AND deliveredAt IS NULL
    AND subscriberKey IS NOT NULL
  RETURNING *

I have this:
  const fiveMinutesAgo = new Date(Date.now() - 5 * 60 * 1000).toISOString()
  const { data: notifications, error: notificationsError } = await supabase
    .from('notifications')
    .update({ processingAt: new Date().toISOString() })
    .is('deliveredAt', null)
    .not('subscriberKey', 'is', null)
    .or(`processingAt.is.null,processingAt.lt.${fiveMinutesAgo}`)
    .select()


It updates the rows, but it returns 0 rows.

Is this possible to do?
Was this page helpful?