SELECT id
  FROM decks
WHERE expiration::date = (now()::date - 1);

SELECT id
  FROM decks
WHERE expiration::date = (current_date - 1);