git.squeep.com Git - squeep-indie-auther/blob - src/db/sqlite/sql/refresh-code.sql

   1 --
   2 UPDATE token set
   3         refreshed = :refreshed,
   4         expires = :refreshed + duration,
   5         refresh_expires = :refreshed + refresh_duration,
   6         refresh_count = refresh_count + 1
   7 WHERE
   8         code_id = :codeId
   9 AND
  10         NOT is_revoked
  11 AND
  12         (refresh_expires IS NOT NULL AND refresh_expires > :refreshed)
  13 RETURNING
  14         expires,
  15         refresh_expires