UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'c0EEXVlSa5ACflOAeV0WylIOZEa8Zwa9V0CjRaoV0rY=' 
WHERE 
  key_id = '3c97e9e004c0f055b3da0d1a41d1f57bb4a8dec713956e4098ae17579bc987b7' 
  AND (
    token = 'c0EEXVlSa5ACflOAeV0WylIOZEa8Zwa9V0CjRaoV0rY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )