UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AgF1AMgK6dkch26Y18XABfxPPkw8ouS90q3EDclE3cY=' 
WHERE 
  key_id = '9c92defaf12185c69162bb11c64fe1900cd8ed189cda877d2229e2a96b8694bd' 
  AND (
    token = 'AgF1AMgK6dkch26Y18XABfxPPkw8ouS90q3EDclE3cY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011