UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hMGqEJv8OiclhpNLPKeCekYtJazXxtb/vCIAxyUiwTo=' 
WHERE 
  key_id = '0f8efe578096c26e447617223edd9be9614355b63c4882b75f2deafe71c9d658' 
  AND (
    token = 'hMGqEJv8OiclhpNLPKeCekYtJazXxtb/vCIAxyUiwTo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00009