UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VlTArAaC1O9gO4zA4M1yyBqq8LHwKleXkjEyCw6pDQo=' 
WHERE 
  key_id = '31f25ce6972f714244a986cd6282eaabc86e426947ca9c905a8f10ce4c72ce22' 
  AND (
    token = 'VlTArAaC1O9gO4zA4M1yyBqq8LHwKleXkjEyCw6pDQo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00010