UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yO1j7io7LLTP4DxaLeeOeJ0TV+YltZovJsy/tSJw94M=' 
WHERE 
  key_id = 'e66b30a0890dc1735485655e0093f08c5c0998c6fc5b71a1fbc44602d5dda7b3' 
  AND (
    token = 'yO1j7io7LLTP4DxaLeeOeJ0TV+YltZovJsy/tSJw94M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00009