UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YF1HEWGkx0G7nlVRXnQ1f3NZllXox4GEEO4yjVBTVOI=' 
WHERE 
  key_id = 'a01704361d6357bc13cbe53f85614ca8fcc6796e18b36498910134e83a8e8238' 
  AND (
    token = 'YF1HEWGkx0G7nlVRXnQ1f3NZllXox4GEEO4yjVBTVOI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00010